/*
 *所有关于processformulamainView类的业务代码应在此处编写
*可使用repository.调用常用方法，获取EF/Dapper等信息
*如果需要事务请使用repository.DbContextBeginTransaction
*也可使用DBServerProvider.手动获取数据库相关信息
*用户信息、权限、角色等使用UserContext.Current操作
*processformulamainViewService对增、删、改查、导入、导出、审核业务代码扩展参照ServiceFunFilter
*/
using VolPro.Core.BaseProvider;
using VolPro.Core.Extensions.AutofacManager;
using VolPro.Entity.DomainModels;
using System.Linq;
using VolPro.Core.Utilities;
using System.Linq.Expressions;
using VolPro.Core.Extensions;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.AspNetCore.Http;
using SMes.DbMethod.IRepositories;
using Newtonsoft.Json;
using VolPro.Core.ManageUser;
using OfficeOpenXml.FormulaParsing.Excel.Functions.Text;
using System.Threading.Tasks;

namespace SMes.DbMethod.Services
{
    public partial class processformulamainViewService
    {
        private readonly IHttpContextAccessor _httpContextAccessor;
        private readonly IprocessformulamainViewRepository _repository;//访问数据库

        [ActivatorUtilitiesConstructor]
        public processformulamainViewService(
            IprocessformulamainViewRepository dbRepository,
            IHttpContextAccessor httpContextAccessor
            )
        : base(dbRepository)
        {
            _httpContextAccessor = httpContextAccessor;
            _repository = dbRepository;
            //多租户会用到这init代码，其他情况可以不用
            //base.Init(dbRepository);
        }
        public override WebResponseContent Add(SaveModel saveDataModel)
        {
            WebResponseContent webResponse = new();

            var processformulamainView = saveDataModel.MainData.DicToEntity<processformulamainView>();
            if (processformulamainView == null)
            {
                return webResponse.Error("配方相关参数不具备....请重新填写");
            }
            processformulamain processformulamain = new()
            {
                ProductId=processformulamainView.ProductId,
                FormulaTag=processformulamainView.FormulaTag,
                UpdateTime = DateTime.Now,
                UpdateUser = UserContext.Current.UserTrueName
            };
            var b = _repository.DbContext.Set<processformulamain>().Any(x => x.FormulaTag == processformulamain.FormulaTag
            && x.ProductId == processformulamain.ProductId);
            if (b)
            {
                return webResponse.Error($"配方{processformulamainView.FormulaTag}相关配置产品{processformulamainView.ProductId}重复....请重新填写...");
            }
            _repository.DbContext.Set<processformulamain>().AddAsync(processformulamain);
            _repository.DbContext.SaveChanges();
            return webResponse.OK("保存成功");
        }
        public override WebResponseContent Update(SaveModel saveDataModel)
        {
            WebResponseContent webResponse = new();
             var processformulamainView = saveDataModel.MainData.DicToEntity<processformulamainView>();
            if (processformulamainView == null)
            {
                return webResponse.Error("没有需要更新的数据....");
            }
            processformulamain processformulamain = new()
            {
                Id= processformulamainView.Id,
                ProductId = processformulamainView.ProductId,
                FormulaTag = processformulamainView.FormulaTag,
                UpdateTime = DateTime.Now,
                UpdateUser = UserContext.Current.UserTrueName
            };
            var b = _repository.DbContext.Set<processformulamain>().Any(x => x.FormulaTag == processformulamain.FormulaTag
           && x.ProductId == processformulamain.ProductId);
            if (b)
            {
                return webResponse.Error($"配方{processformulamainView.FormulaTag}相关配置产品{processformulamainView.ProductId}重复....请重新填写...");
            }
            _repository.DbContext.Set<processformulamain>().Update(processformulamain);
            _repository.DbContext.SaveChanges();
            return webResponse.OK("更新成功");
        }
    }
}
